Skip to main content

executing (XXX.XX%)

Short Description

Executing the SQL statement

Detailed Description​

In CockroachDB since there aren't currently any wait events, the whole statement duration will be either preparing or executing or executing (XXX.XX%)

The percentage figure represents the actual rows read versus the estimated rows to be read.

How to reduce this wait​

If the percentage is well above 100% this can indicate that schema statistics are out of date and should be updated so that the optimizer can make a better choice of execution plan.

Search online​

If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.